SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 69380 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 69380 [ RunTime:0.002928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600780,804525,416680,227760,1002987,495500,140206,195611,37219,448340,236802,885299,181818,1030769,430010,137997,729721,837969,909482,469650,717372,123156,984162,29326,631633,439226,193243,63746,476189,134337,298707,967341,360814,177904,47082,796625,1038174,898295,905166,829980,666320,384326,210370,38662,489151,473629,549800,829058,848936,221768,713009,275061,972915,900113,260099,677092,832693,476173,704870,23160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 69380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 69380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000737s ]