SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367315 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367315 [ RunTime:0.002337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420136,838494,1003011,106054,611312,131301,442481,747882,223922,54731,902462,509236,485983,450994,680443,624110,282993,698536,693359,783131,445346,795244,840100,1045385,607276,907395,996845,289372,39136,641796,837401,1005358,600365,828102,165193,703477,694975,383270,925364,738322,388635,951278,787251,655139,166531,1003803,205841,908367,321880,971858,966887,3231,388969,692420,1012713,725869,869499,90159,688920,271986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]