SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804008 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804008 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802534,806249,657286,88289,514948,61245,537625,131330,584147,108615,923337,484709,795015,292239,166626,440656,863620,384388,988658,205024,808939,1000047,562334,42106,361996,309336,961330,442745,935991,606489,410197,4565,51091,590437,731817,827667,802887,808921,168571,358765,186989,1007654,615326,612485,965076,684999,1007737,851094,643694,286643,145419,1012167,109096,589341,387783,788161,1043811,774094,284586,391894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001904s ]