SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 670493 LIMIT 1 [ RunTime:0.001908s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 670493 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81081,886358,574943,333747,493730,967827,21795,906131,997250,157576,268892,360196,104905,352655,800512,520252,1033353,54026,441827,1025072,188326,41272,732751,413602,32431,588564,583639,1037675,764903,68090,25813,776683,725841,647140,716721,110996,145144,294579,163646,225383,578416,255364,199854,8365,502933,114624,960572,609324,77400,970251,141014,272294,891590,251433,765592,179677,657316,424409,900904,359551) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 670493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 670493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000742s ]