SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415401 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415401 [ RunTime:0.002111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46615,20336,533878,849567,643553,49367,645909,58863,593141,917706,539449,650869,620351,581038,701034,699683,361787,412380,13659,427825,590443,985746,6213,657629,118801,65740,169188,593465,467679,379003,1004992,766,531235,495681,370592,1022547,448979,731039,647101,230151,7294,770004,320406,264416,235122,438288,15958,203574,477264,402566,825650,956918,493786,745501,995637,16636,408030,1018413,876274,954444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002285s ]