SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001583s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 240628 LIMIT 1 [ RunTime:0.000979s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 240628 [ RunTime:0.003359s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111100,581421,421825,619664,50777,558286,1015208,1003239,220174,830111,941943,734033,724046,680161,341896,69750,876414,780760,392556,73933,418571,874012,679594,940422,322174,1004498,158221,401817,155158,730214,593847,413677,1045806,706725,136222,849807,982213,1029321,347394,856685,90690,465761,428335,202382,567560,748929,960013,594472,237398,677772,879276,982421,210421,1021329,1008617,853395,554841,648336,598144,87202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 240628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 240628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]