SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001817s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393273 LIMIT 1 [ RunTime:0.001070s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393273 [ RunTime:0.002111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984517,304057,352963,398407,10334,109873,623256,392931,896685,453339,355283,284857,1017785,519923,446712,957934,429129,105131,33634,282530,1006707,675803,135085,329764,285536,358157,861426,1015384,150634,372175,302355,69798,199659,428319,125995,46754,698811,1002713,86535,145433,206078,135710,454816,668340,116539,35386,832544,171769,791429,787681,478665,945277,188104,597582,80640,1042390,315224,106777,755047,45657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001690s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]