SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404502 LIMIT 1 [ RunTime:0.000539s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404502 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418848,4434,868506,850167,911117,668422,476102,830899,142271,968315,271138,1003812,210896,381705,1022171,182719,184714,635419,154396,153625,1034688,478420,999620,754566,344782,595866,358653,972095,466116,451889,68375,638040,1008863,183098,975116,42443,96123,533126,561038,780357,358167,814081,634630,692527,355950,512174,306700,581292,498588,1017547,776534,224264,152761,162595,37154,1001466,320022,44116,174092,183214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]