SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291261 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291261 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596073,339409,399889,819274,36399,993797,1020337,812745,277688,941733,453262,44935,318015,7525,106602,597355,818497,802152,838871,275356,863840,161998,962524,26038,827399,855187,410961,855601,200185,997073,940360,990997,690082,410807,689073,977840,16003,653588,873430,46269,1031163,198546,228055,538448,412047,693277,156599,463030,584951,519337,738641,425494,699825,833923,858945,593737,156407,1033652,1012834,429007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291261 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291261 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]