SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539335 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539335 [ RunTime:0.001375s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182599,954707,352247,687369,557279,9933,560773,564325,204677,1003895,224512,603654,466098,847454,529681,332057,382061,404854,240619,641711,721089,229651,995882,960781,298856,656339,818095,668478,843595,751468,76209,286220,614343,616875,369641,220335,1042950,494308,1000729,723834,714680,1000489,214690,666017,490820,1010830,724867,616475,646036,957805,525125,20100,290910,551404,27074,191853,765412,901464,738422,620582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]