SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413713 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413713 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621247,847719,403785,861534,48103,1029580,724636,34900,754594,651076,645666,273243,869736,68544,618775,418442,199893,428437,747794,1043957,46722,987096,985165,647402,187050,44042,709193,560367,1040566,681243,329160,593992,846383,269726,172591,958247,197391,623130,457297,763670,889514,242425,175166,275018,301777,20023,396719,926585,552519,636975,943231,991737,939933,426866,64563,106584,1040066,758688,83607,1362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001290s ]