SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011750 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011750 [ RunTime:0.002130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57963,764092,319849,50773,347002,324649,700424,670866,283900,558418,842001,263017,528811,88149,686623,75176,456686,498848,639445,537496,222280,248474,517821,429458,71015,163765,233872,530109,28049,779234,695542,974177,648336,215542,520308,558179,922117,694234,463184,472003,541981,481724,763972,745405,424112,234768,103975,12436,1003379,308198,718140,437119,858798,647716,941191,268022,952247,414069,217262,150157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]