SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003492s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802661 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802661 [ RunTime:0.002221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471945,29618,88574,511971,670613,141733,896838,848853,349587,510331,861610,497780,348036,254357,1004107,288400,454614,870819,193133,276518,702726,120783,874064,589103,88455,370333,874137,1013578,108686,597104,208974,702359,995950,589923,361361,805128,435093,396352,287413,488140,229218,493814,760815,789648,1006438,395552,135785,51106,564195,718899,992300,233618,1018739,944310,925484,30087,73602,189543,480794,654863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]