SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522012 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522012 [ RunTime:0.001997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515384,546001,472921,1011836,92930,601659,545306,379396,109387,327226,641561,910711,265914,752138,764771,924044,928365,193142,978154,327523,765615,864298,456324,355341,920191,97199,707459,385188,628012,795633,658594,243633,908889,999005,295437,69524,782275,55275,165834,826895,294693,195477,876132,820979,991293,909269,437454,1022106,459644,1040103,716501,750912,312543,874359,59793,728463,366322,806343,480145,863687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]