SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 189880 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 189880 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765642,26140,811448,209949,940059,1012499,11118,1044388,801665,880174,114171,802945,284867,785751,421649,712193,106643,915192,786414,397165,604734,602510,452103,73540,207488,22970,887756,672238,573723,386871,632304,953874,128685,640351,560638,496392,740889,241672,742151,169102,21073,287827,425269,909134,246121,889886,712475,653821,488397,958599,965858,151161,111688,1022429,868585,928901,414002,860119,162523,448940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 189880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 189880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]