SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471883 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471883 [ RunTime:0.002693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514657,159308,591648,517675,514184,20206,473061,163469,816640,423461,537793,445580,259615,337107,514534,2481,140247,325558,658411,572708,113394,28044,323254,286380,348091,701992,630112,668689,399957,633383,1007676,63429,878394,430523,73689,879588,623599,219173,428315,178734,1039360,169892,961488,34871,780602,538429,64780,679728,589613,251755,766691,25862,337023,329046,781989,31212,279935,144951,412484,692527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]