SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044114 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044114 [ RunTime:0.002836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730776,36087,855256,340010,67443,188322,271058,599113,232768,791598,547548,116827,545799,389482,256886,194847,410510,359128,947923,319413,416276,1004714,709227,358745,24849,738076,905945,317735,237694,920078,1046986,822505,413010,43873,501044,515833,934509,282921,877258,701559,274806,424862,383672,371796,979177,512330,803714,690805,17573,29284,613252,16083,546194,9013,537014,862869,879708,975892,927342,158013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]