SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001415s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342611 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342611 [ RunTime:0.002369s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706007,26767,560978,989438,354864,1000066,925565,352180,705327,695347,953539,753907,575668,103860,524049,835151,820950,521859,786979,406436,442586,15934,710426,327165,894298,68854,768862,176532,103560,217337,1027013,810666,828489,591911,983190,342599,577498,450261,514440,623016,199198,490292,653159,694679,242408,545013,8663,524501,316583,179186,693859,362185,69737,1004566,582229,405277,402421,672695,149189,413713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000861s ]