SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013207 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013207 [ RunTime:0.002483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564635,451130,652357,358815,714650,308033,225504,27580,1045108,6562,685840,69703,781181,944227,1031901,183392,776534,632314,587475,1048355,291090,510475,56477,320880,864344,145751,683345,307560,850885,133043,744549,766855,235612,99615,740287,862008,299977,909730,89547,569811,899754,876240,41390,851378,949650,549510,337455,991081,621305,782161,539831,660132,1042222,114511,703363,721340,535944,991913,1022184,734105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]