SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 112313 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 112313 [ RunTime:0.001997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107734,755992,109770,307986,883838,147435,842772,479364,760294,508580,453198,425315,1036573,46625,807302,837334,629500,459470,135651,417823,940274,1041939,621528,1046000,1044271,816381,573489,929011,777049,42052,785627,1010462,732206,146597,893624,694686,740079,329543,336124,916046,597357,799588,519977,235069,862184,710064,785666,925345,830845,845606,203950,23919,816092,814040,1041882,980015,904996,214301,205922,37863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 112313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 112313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]