SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44712 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44712 [ RunTime:0.003594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026942,797224,408396,915622,907098,292945,114564,348682,912328,212145,514889,870673,642012,530501,110371,442944,941514,954421,877667,974365,649436,602927,420536,594577,739307,36611,602457,986530,1002195,841744,155504,891676,470758,674294,211968,391529,703142,58085,313780,20588,323146,90125,825137,666828,181206,604731,807419,466675,932219,794758,495379,93448,236800,125025,841473,825176,49039,495806,778393,164872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]