SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345159 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345159 [ RunTime:0.001989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033526,115964,1043231,80528,582432,803110,209612,746154,135568,610781,716108,339631,1044267,1001175,680060,409013,603546,591506,951596,944323,989175,716250,59713,970539,610005,321994,989242,373049,923885,1029521,693904,467264,341815,695961,568731,567379,689032,2609,290313,725264,492963,660847,687825,203809,930492,42181,702325,1037059,1002131,399014,798925,166005,55628,703837,404166,975545,314105,756796,335980,831332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]