SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517771 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517771 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599160,1043561,661166,207052,742643,407544,935001,349830,741905,988384,8978,219207,33497,316091,520230,479447,902791,505218,290394,222304,807061,582950,115512,502165,306183,609237,771870,881236,107019,696980,875394,162939,818521,266666,699022,986770,200780,830026,955144,994136,156095,24568,968824,415144,951562,257044,148066,5814,685635,772020,447384,470959,298807,618303,954561,1029478,255473,1039690,1007218,39891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]