SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553320 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553320 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403590,687098,455969,50045,493577,576476,857064,390571,601193,1014324,7955,288016,29648,502561,503887,1028417,1010638,450176,218765,469196,290241,844056,368348,281377,318002,581143,88967,609723,640589,124037,605873,649205,117584,342818,847708,258991,608795,943201,641375,569893,908918,425611,124858,225960,291291,431121,582762,530476,921140,747761,936284,684055,74611,336777,573025,71683,79666,495325,748405,817209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]