SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019591 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019591 [ RunTime:0.003085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554556,704601,759319,798816,2633,233576,75399,84886,226948,231369,240149,810617,16630,98651,840732,133951,340554,990228,178978,798510,958051,638051,76101,646853,52343,102939,770328,213269,418428,969109,819843,404945,409552,444809,191282,42010,96378,346497,931225,783937,88329,387294,341636,802874,221620,234973,459172,755664,167141,888903,674260,746994,202278,676603,237134,613606,169063,12638,811801,397608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]