SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516168 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516168 [ RunTime:0.003121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169131,383077,1017280,970388,971324,733176,833681,696231,347788,299952,107068,1023384,82989,326927,664474,848587,350414,54281,550124,1014926,236220,638683,102460,100355,186529,832081,792233,796173,941427,145211,441948,769603,114043,649941,707836,715818,665597,179950,558050,910110,253816,793640,357708,899656,414358,97065,55991,503108,136582,21699,831451,765242,800152,910798,181257,242387,210651,556788,440723,753116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516168 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516168 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]