SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263547 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263547 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524516,131938,191489,102059,161805,1048153,33245,583488,840091,715172,278125,402983,89148,480294,271250,522883,785107,390021,996050,736206,68341,725646,335812,943667,456263,259723,485567,101313,455005,212645,392345,891357,529127,551446,964623,615904,340904,403872,273204,841386,274956,807957,632589,705449,595135,118982,391689,614866,843289,40960,747970,566313,554288,1032466,794965,644206,994917,962446,310091,113595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263547 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263547 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]