SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002070s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011926 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011926 [ RunTime:0.005783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697392,930492,599618,368755,515855,431991,397783,326491,636561,478554,119059,960681,494468,535358,472158,378191,1032620,907108,1026507,332019,3047,597351,88494,942526,795622,835228,67699,587849,726806,516914,113654,158964,301400,161946,738397,1041522,97681,586811,705784,121655,73118,190407,443322,913877,790530,196017,602754,323468,268308,211256,1009083,914637,418573,112506,748466,34900,789295,724547,885399,738041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011926 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011926 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]