SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508013 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508013 [ RunTime:0.002633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414131,236358,315475,301592,394253,279695,518723,388536,315457,285090,288280,744802,182448,204883,737071,495391,511993,450316,157788,680120,537142,404949,918700,968517,604770,952468,197420,721196,401857,702711,957451,300553,319063,245339,407619,142529,26534,712262,563343,139102,165457,368769,296273,345146,46302,592362,643553,859300,336254,403204,196857,327306,21633,545535,583003,811841,81354,504205,160165,430286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]