SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435941 LIMIT 1 [ RunTime:0.003233s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435941 [ RunTime:0.007212s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538552,469673,868728,682633,762380,856196,647238,861484,865117,26079,578738,120836,837659,244424,33646,249497,192753,172769,686978,247214,281059,309612,778551,928723,972475,951407,674179,1046530,976605,258140,995958,680357,221136,263628,255717,1021176,240386,162462,816290,14481,242268,353842,624845,222483,1032051,286324,448790,829178,339181,739886,368035,938456,209516,158109,853111,538426,389576,1015719,466842,810240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.009387s ]