SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398628 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398628 [ RunTime:0.002420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808460,548814,468079,781323,516805,737404,494544,617825,36569,849199,514904,1006994,720044,1000126,101306,641070,125952,688364,234990,89649,580090,698316,415337,979758,141037,934647,801406,915752,545979,274110,312416,687035,818441,646248,372768,438473,852294,234506,229531,306631,109711,970465,464021,952636,279186,974602,632155,290596,408289,196857,138237,294116,357184,529021,208464,1031163,723957,1004895,540991,109379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]