SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004538s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3102 LIMIT 1 [ RunTime:0.000891s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3102 [ RunTime:0.002830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625227,717384,646075,444771,129777,702393,459198,363505,709480,601513,600099,593021,955623,845192,704911,753809,232467,362700,439339,894286,567762,447213,618980,588683,737218,39734,899360,172924,424421,192391,797469,112268,833620,495933,832089,387757,296679,937001,675567,444366,1032541,904062,185555,153697,36873,606955,711904,800935,392904,925273,1005181,413216,391328,976335,115458,907383,572794,841019,763303,116867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]