SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190988 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190988 [ RunTime:0.002963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576237,500541,356767,387354,797402,290089,814772,300048,520378,904947,43138,587061,1046377,57817,839894,912753,335202,977562,409870,82260,2300,674619,60149,642505,775727,105723,107111,78196,540793,84945,6448,1005480,555539,133714,69666,1037471,41450,1045294,981827,417900,766735,438736,597998,643852,347572,85600,302479,880964,882569,389256,977819,808380,10134,553702,580974,699350,228849,1006641,607192,361947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000714s ]