SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546258 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546258 [ RunTime:0.003956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802251,529382,102073,695295,69489,366792,466935,493554,24096,891704,417773,1028380,440990,367119,352629,133801,425316,791642,380150,15003,816303,499795,274272,831375,999684,676990,215487,182927,96932,940145,514103,520239,456002,217336,13634,869654,431062,1045324,674446,830777,723896,734663,704430,908480,77570,158150,929658,722073,331201,462649,474442,348035,855273,830601,664255,134138,921883,976150,925646,269537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003967s ]