SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 140809 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 140809 [ RunTime:0.003915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924166,747475,903977,791273,718767,446093,258130,1013998,733699,907379,359660,794165,600928,252681,660413,177982,910361,300362,71536,94238,372019,21845,596239,83272,676135,912214,60501,125611,274274,701864,377886,858942,255232,10302,162797,1014585,612710,452340,688330,13019,710381,192712,976115,358490,554205,137320,29079,174645,25408,43456,175490,213097,209915,697583,586215,1009600,866309,306781,413613,887885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 140809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 140809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]