SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412861 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412861 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536455,442060,311535,154139,758368,1004932,819550,722279,765822,795906,536747,418046,700010,363495,517847,658275,484375,412316,250933,628731,214888,41506,942170,319434,592703,707689,659859,615605,856430,150324,15912,978439,219790,867942,732978,134276,11462,836027,11948,678883,928817,182018,932849,936416,914603,171518,469550,675763,583722,1031265,193174,547289,895903,364184,873610,265787,289818,194195,679297,465364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]