SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024010 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024010 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171774,819029,682266,719298,336964,793710,1021096,590800,751464,529563,435545,692959,176733,467035,320753,150606,635504,636202,896901,477651,899608,11859,797471,794783,1025778,47634,535175,678250,801397,596836,31246,856204,91383,23793,923423,635248,200730,660512,760939,531859,895797,348470,484666,83369,681074,40731,523471,464995,904675,278521,86757,197950,93871,610857,998579,288652,958465,414268,576013,1017347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]