SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457580 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457580 [ RunTime:0.001469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376865,476338,52977,33725,507869,451301,994413,921337,177801,29202,872158,33911,41820,932372,207368,571083,627032,390286,623252,277981,557811,554020,757576,402553,531993,553118,688674,569409,583661,564523,451971,263115,881917,771207,360213,507052,967333,564966,52816,396522,738496,884733,640182,651163,467180,332885,381220,143487,855045,689567,812241,1018483,103991,995789,298439,433601,335443,899103,958465,114398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]