SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26801 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26801 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394121,618589,441589,379065,240226,446604,190946,428804,826544,833694,1047387,338477,183829,206313,228227,719510,364693,475369,869775,873332,990921,791968,135614,808724,703204,118319,874977,488505,874456,983477,588602,52719,712472,647358,658915,213047,604879,810260,843529,25010,465500,891353,818499,844187,78531,455288,750066,209819,468783,306035,1036811,627413,206549,678143,389234,207951,973554,193878,404905,1004272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000711s ]