SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100710 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100710 [ RunTime:0.002310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811836,197676,39434,534536,1000620,953885,179940,666525,826686,943151,328985,163851,25142,34046,535809,597850,263133,162809,731494,843534,892470,33758,371612,766613,894169,674864,266427,963277,397474,612892,530949,433528,579870,723721,847499,641097,299042,342573,552879,75776,301637,389481,852885,330246,301228,55619,729213,128496,1032105,353561,575841,272593,201202,771635,57328,408111,785345,438016,686141,563975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001444s ]