SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001696s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 189821 LIMIT 1 [ RunTime:0.000561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 189821 [ RunTime:0.002347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290094,931579,402336,973459,479590,229961,64751,908860,56148,998420,511308,305231,156180,304242,341479,991352,823541,110332,662642,379227,584194,431311,996504,766674,127627,982920,1035085,212375,57007,179917,432054,494673,46826,954802,541217,623995,446789,738916,313166,151140,196908,408034,145526,192561,11981,440622,514433,74651,419025,471104,552618,528246,285349,932830,88103,555573,71966,862084,378264,202057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 189821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 189821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]