SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281763 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281763 [ RunTime:0.002090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428105,414862,32916,159437,513689,575283,108256,744551,408936,969150,469885,246726,292549,818451,741478,4160,378103,907109,711312,911414,171311,403183,893097,572156,802389,753661,851763,640434,106108,457254,320531,942249,67808,48692,367799,305833,623945,68472,678954,661406,406680,92439,38520,169091,164499,989588,302225,517820,602113,979166,679167,993194,166907,474426,630960,585040,69233,126003,789401,103694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001824s ]