SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570883 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570883 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (854141,430534,57496,231478,890135,557040,946981,802979,889803,726784,97553,743884,665110,855530,749778,596940,763873,16361,883906,326592,245617,427005,127761,121591,512344,219471,168640,873746,571531,971239,1043918,759565,832375,413092,819019,940847,989187,124906,27514,914121,277158,815438,83646,570532,263804,863139,765631,447274,672967,784955,328907,669072,329624,417085,57483,187003,317670,116484,844273,100434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]