SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409850 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409850 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012684,817421,632539,124796,546566,603319,1017857,24751,455058,298933,726195,1000726,232206,456457,2351,716600,169813,740044,779625,339195,851790,569004,19779,312320,812581,992167,791247,499162,539654,898354,184492,208355,86026,343692,269393,224174,245778,675708,686422,966783,127792,996589,439879,358713,447447,82727,751949,471057,1010733,411582,810415,896947,823809,465270,971061,172493,783526,88575,190766,828596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002621s ]