SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367230 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367230 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035855,250638,222593,631154,511442,340291,720080,561167,822353,659818,1032338,775566,74611,1026075,1003489,19310,531872,204393,157807,953884,871736,727044,540354,503728,23726,892767,962803,286102,442225,157278,616921,450898,658587,394960,43808,585785,112967,863716,633722,991828,279065,591362,739453,593092,789880,766087,270545,589618,249797,759149,666283,422961,415888,342290,112448,28818,201318,437740,959872,647156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]