SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039226 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039226 [ RunTime:0.002453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035512,433072,645863,551922,791832,971157,472934,623281,70202,909453,272525,824140,279497,78108,132406,130690,851588,787438,985612,556056,871304,351578,1025856,798132,621119,894223,53171,852079,250816,1005528,752544,268589,102331,123039,881175,55225,1012830,472069,534446,489666,997555,678452,685024,607505,231194,730644,1008056,96041,394980,366662,781970,932960,593358,176622,547085,1011946,417576,283113,939654,425640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]