SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454164 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454164 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527730,838092,735300,406064,864344,74796,5266,242756,126838,545479,370335,30778,744796,881480,103511,882816,190209,72305,105998,556164,246445,648389,836146,295753,400034,550574,727491,570906,255814,891961,707688,8290,498772,498129,33747,976639,400726,235708,893138,189520,173975,301746,284949,140305,801933,633818,1036739,752060,506346,676110,470796,580928,534382,240090,146509,827680,866081,962647,111554,231759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]