SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 151683 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 151683 [ RunTime:0.002335s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043281,606503,1031412,913380,834183,885026,1015632,722658,710042,898421,347998,760690,1041126,906537,556636,1043224,890246,202762,1024338,930613,987068,198087,664966,464919,409498,374546,338672,563794,689640,421287,232169,235857,266185,941302,195851,790453,474545,537908,406543,184988,215680,823942,350842,671800,22525,977186,427155,592148,852767,699579,238238,136690,749647,273220,65884,695828,703260,885384,361452,834721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 151683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 151683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]