SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495078 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495078 [ RunTime:0.001982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (985173,14661,747766,253352,860517,464992,260419,1021210,47629,172106,881915,438302,472515,439478,948086,789170,896153,745005,561547,433647,280138,787087,235107,398473,1027433,158443,279222,458592,802721,241192,325456,1015970,593388,516493,873342,994574,500204,233897,349445,209681,581927,349983,409442,720548,1008496,213538,594976,915246,462240,926125,689570,405523,797495,1039341,346112,34084,180783,68831,522711,1024625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]