SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409170 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409170 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987565,974705,656487,976905,367879,243905,875146,155310,290566,1011283,402589,750212,526256,409450,346516,414649,420859,710875,381464,84850,849213,106873,634839,193951,154957,360433,722137,352043,459946,966178,152446,233996,193143,315297,23780,157120,1021051,1015198,652041,177340,153047,844571,14123,459720,446973,835662,534918,985592,165902,617109,1037622,782684,851619,58493,560357,916642,693161,282994,269438,329713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]