SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487922 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487922 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996710,167646,285188,862518,830534,446070,1039588,249217,100896,890997,788301,180599,241068,582927,64157,312087,780100,654349,15758,161474,944236,451792,147952,63596,560341,523832,33463,149253,546157,456141,806079,197444,237377,409679,676388,388761,470415,917870,199852,179599,150523,815655,809683,190810,678037,430054,798204,360523,1015246,598753,630023,823883,998280,864979,694766,380857,775834,359776,458322,279561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]