SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341707 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341707 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13179,626250,646187,585124,934885,1034015,902873,76350,98180,23220,1046367,349196,132245,676536,463536,807024,394292,722908,962786,520335,958706,293283,359938,710429,969871,813575,627163,805525,20224,741879,466206,959473,55439,44367,469560,279622,751722,783785,663338,535306,628773,111100,190941,265950,465593,981429,137665,190937,56061,291827,514966,539370,336236,694771,955206,818002,807826,332063,505258,493997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341707 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341707 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]