SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323319 LIMIT 1 [ RunTime:0.001076s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323319 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220977,783120,606260,794692,199934,697300,506053,170036,625952,97246,571191,126157,235938,762420,805217,10981,391144,809831,595258,189570,807933,402276,272447,633066,49258,1048599,70088,716798,395677,585316,722176,201779,165151,451092,265060,761960,184465,24204,1005313,572704,625609,337439,923573,873194,403792,744867,359465,255406,836368,721320,144359,1026088,867194,84630,6661,671145,535377,190809,581426,251832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.022503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006302s ]