SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671912 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671912 [ RunTime:0.002317s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287795,902408,443072,963963,199550,103428,956161,1036632,87704,941909,28241,809259,232028,1047406,389699,264966,146052,373059,15677,307907,391870,973474,823881,922590,121287,855204,981907,132139,245043,621104,919802,160717,935845,362331,395157,1045699,82552,121373,687269,904559,966774,93476,316208,719099,137123,546767,470743,301239,856739,681890,415342,927089,837124,646295,885520,665873,181969,206501,1021741,669122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]