SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043861 LIMIT 1 [ RunTime:0.000615s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043861 [ RunTime:0.003652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021158,882142,146973,103385,30451,845922,945033,7296,881465,803614,862668,1020599,829361,145951,636047,107279,665729,932770,176161,309963,799528,974728,812404,268404,813981,217563,287919,981132,212537,354655,580092,169690,379731,750615,886067,942218,396542,185106,241390,540437,109196,569935,315222,279422,265747,514164,901932,204135,284331,793540,600547,94988,125047,198340,52877,565926,886488,503063,379838,899980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000747s ]