SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 908910 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 908910 [ RunTime:0.002525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551761,734191,1033366,312048,273422,550449,805346,636572,1025650,873159,4933,495387,32557,394397,1032618,211218,118281,680803,626531,368421,135703,611066,941679,1044,506755,1003481,1033612,285694,831776,110567,341867,446966,573879,312821,821449,861854,427269,752731,134094,120243,1002274,993663,335133,281211,61508,761832,858707,149718,319895,1031407,838426,938395,834869,192693,106078,962589,140892,903327,404075,248778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 908910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 908910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]