SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035141 LIMIT 1 [ RunTime:0.002469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035141 [ RunTime:0.005233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167204,595794,325516,1040366,601809,795608,88353,852529,870039,97349,203549,514179,534670,839582,404586,101401,296004,925389,574470,269888,570521,993645,125183,949161,165487,494662,835231,271752,1011784,618739,43559,10203,811315,678384,847872,868114,73799,540112,836210,331943,886182,128227,892287,843980,360044,914397,837434,736350,114141,16885,44423,350211,940398,269391,557751,717206,545067,614250,958392,570497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]