SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111015 LIMIT 1 [ RunTime:0.001509s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111015 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639376,797204,438741,488909,393810,757729,402343,852447,536317,230661,158913,611498,480088,839927,771393,172968,214577,831228,75632,854754,264774,541181,360269,944870,875639,138395,137798,818834,598495,462381,188657,284837,209406,772282,16493,351665,61327,923597,740581,768122,816053,231501,404760,477247,411109,500860,1029068,721654,996505,929489,814393,484207,103884,1016444,1036686,468,538825,146489,1046602,392080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001128s ]