SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001899s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284054 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284054 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498917,559903,65534,549805,924967,973401,714893,167257,877830,135857,584456,5609,819237,196189,749936,18650,776182,800355,146566,325996,75623,296827,42633,864293,977304,624258,457137,329317,899102,788572,812167,1003817,749926,849280,372535,322296,200085,109286,132081,142218,726333,909282,59813,134900,811546,896492,777482,340990,467757,693229,346061,1000625,564056,253364,956867,611862,415568,50987,981025,847411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]