SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438309 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438309 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1595,38150,849130,949055,714658,787075,402379,1031745,936369,896095,1043268,82414,200005,864547,612707,283730,235219,169833,74576,73169,679649,44712,533092,1013205,315747,728944,572208,157415,598661,268542,594522,679896,465193,72139,651404,929182,256539,143239,547196,251486,335771,155496,36612,29444,960739,877557,336500,173118,657755,208082,1028765,336498,424444,678127,709449,110273,663462,252639,782298,972198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]