SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281711 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281711 [ RunTime:0.002144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (962838,81212,269022,991095,391909,482964,124570,999724,133206,771450,918553,687379,488293,188339,982028,535961,899973,850393,76634,59146,651486,2770,197755,315991,21622,880774,629467,511048,734298,561297,501033,843217,382740,1042745,441917,791682,531722,641635,372367,924963,910012,970603,879813,918556,635061,32573,214162,168634,974695,409702,517069,551739,973353,621876,317304,994116,393525,270258,7421,945449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]