SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515748 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515748 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153810,260686,893206,251627,802712,842857,162975,129196,983020,843887,219675,670869,287600,574515,338814,577705,1032786,870189,257555,586061,894435,168464,364165,386639,490032,165269,277178,467058,245977,722223,605163,891064,311777,31805,1018477,814360,741731,573974,167438,1014284,1015882,116536,710304,796577,728192,740495,80072,512334,560602,401090,265267,833411,307478,397001,665416,572578,469765,346414,236592,973931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]