SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43483 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43483 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334844,1013843,406825,813182,570562,20786,177908,450873,566825,136430,429121,213311,541105,715686,648759,537897,334584,462138,95908,532381,692742,213383,51040,438156,91645,65541,478905,912323,446632,626429,502718,110360,629856,306025,192578,521238,159124,287490,260108,476229,1020053,817813,125416,244010,116759,623820,15645,87895,510208,543524,200901,593443,630174,123383,862241,776418,700239,846181,166718,597219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]